Multi-Excel Editor

Unlike Microsoft Excel, Vole Excel supports opening multiple excels in the same interface, greatly improving the efficiency of writing and comparing excels.

与Microsoft Excel不同，Vole Excel支持在同一界面中打开多个文档，大大提高了编写和比较文档的效率。

Multiple Chat Type

Vole Excel supports multiple types of charts, such as: Column, line, pie, bar area, scatter, stock, doughnut, bubble, radar, treemap, sunburst, histogram, box and whisker, waterfall and funnel.

Vole Excel支持多种类型的图表，如：柱状图、折线图、饼图、条形图、散点图、股票图、甜甜圈图、气泡图、雷达图、树状图、日射图、直方图、长方体和须状图、瀑布图和漏斗图。

Formulas

Vole Excel has a powerful function library, include: AutoSum, Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig and so on. The formula written in Vole Excel can be read and edited on Microsoft Excel. The formula written in Microsoft Excel can be read and edited in Vole Excel.

Vole Excel具有强大的函数库，包括：自动求和、财务、逻辑、文本、日期和时间、查找和参考、数学和三角函数等。在Vole Excel中编写的公式可以在Microsoft Excel上读取和编辑。在Microsoft Excel中编写的公式可以在Vole Excel中读取和编辑。

Data

Vole Excel support filter your data.

Vole Excel支持筛选您的数据。

Review

Vole Excel supports protect sheet and comment. Similarly, the comments in Vole Excel and Microsoft Excel are compatible with each other. Comments created by Vole Excel can be read and modified by Microsoft Excel. Comments created in Microsoft Excel can also be read and modified in Vole Excel.

Vole Excel支持保护工作表和注释。同样，Vole Excel和Microsoft Excel中的注释彼此兼容。Vole Excel创建的注释可以通过Microsoft Excel读取和修改。在Microsoft Excel中创建的注释也可以在Vole Excel中读取和修改。

Save this sheet, then open the Excel file using Microsoft Excel.

保存此工作表，然后使用Microsoft Excel打开Excel文件。

The easiest and fastest way to print your workbooks

Turn the contents of your workbook or specific worksheets into a printed report or file with a simple method call or using the Print Dialog. Use built-in dialogs to customize page margins, document orientation, paper size and many other page settings.

You can also shrink a worksheet to fit on one or multiple pages, insert row and column page breaks, add headers and footers, incorporate page numbers, current date and file name to printed worksheets.

And of course, Vole Excel can also convert workbooks to PDF and HTML.

Excel compatible functions are built-ins

Over 400 built-in functions (mathematical, statistical, financial, logical, etc.) with array formula support allow you to enter formulas and perform calculations of any complexity. You can use basic mathematical functions to aggregate data within a spreadsheet or create complex formulas with statistical, engineering, and financial functions for advanced data analysis.

Spreadsheet API allows you to create your own functions. Custom functions are available for all spreadsheet calculations, and can be used in formulas.

• RTD Function

Vole Excel includes RTD (Real-Time Data) function support.

• Formula AutoComplete

Eliminate typing and syntax errors when creating and editing formulas with the built-in Formula AutoComplete feature.

Create multiple documents at once

Automatically create multiple documents based on a single template and include unique data from a data source. Integrated mail merge tools include:

• Mail Merge Design View
• Field List Panel
• Parameters Panel
• Mail Merge Functions (FIELD, FIELDPICTURE, RANGE, PARAMETER)

Vole Excel Data Source Wizard allows you to connect to various data source types (Microsoft SQL Server, Microsoft Access, Entity Framework, etc.), and save the template with the bound data source to a file (XLS/XLSX format). This template can then be used to quickly create new documents and reports as needed.

You can also create master-detail reports of any complexity without writing code.

Summarize and analyze large amounts of data

Embed an Excel-like pivot table engineered for multi-dimensional data analysis and cross-tab reporting. Pivot Tables are highly flexible and can be quickly adjusted.

Once you've set up the data layout you need, add a chart to present information graphically. Our Spreadsheet control supports sparklines (Line, Column, Win/Loss) and a wide range of 2D/3D charts:

• Column and Bar Charts
• Line and Area Charts
• Pie and Doughnut Charts
• Scatter, Radar and Bubble Charts
• Stock Charts

Intuitively present workbook data to your users.

Similar to charts and sparklines, conditional formatting provides another way to visualize data. You can highlight cells based on specified criteria without writing a single line of code. Cells can be highlighted with data bars, icons and predefined color scales.

End-users can easily apply a variety of predefined style conditions and make worksheets easier to understand. Integrated Ribbon UI allows end-users to add, change, or remove conditional formatting styles much like they do in Microsoft Excel.

You can also use cell styles to apply predefined formats, and other manual formatting options to highlight important data. Cell value formatting options include:

• Style Flags, Predefined Cell Styles and Formats
• Rich Text Formatting
• Format as Table
• Custom Draw API

Organize and search data easily.

• Outlines (Group Data)

Provide your end-users the ability to arrange related columns and rows into collapsible groups, as well as to create a quick summary. Outlines can either be created manually or automatically for an entire worksheet or just for a range of data.

• Sort Spreadsheet Data

Sort worksheet data against any number of columns. Treat cell values as text (to sort alphabetically, according to the current culture), numbers, or date-time values.

• Filter Cell Values

You can filter data in a range or table. Enable AutoFilter and filter by values or use built-in type-specific comparison operators such as 'greater than' and 'begins with' to show data you want and hide the rest.

• Find / Replace

You can search within a worksheet, specify whether the operation should be case-sensitive, and search using regular expressions.

Protect your work and prevent unauthorized access.

Password encryption prevents unauthorized users from opening or modifying your workbooks. You can restrict changes to workbooks, worksheets, and specific ranges. In a protected workbook, users are not allowed to add, delete or rename worksheets.

Various sheets can have different protection levels. For instance, you can unlock a range for some users while other users may be prompted for a password.

Keep your data clear and accurate.

Vole Excel control gives you the total control over cell editing.

• Auto Fill
• Formula Bar
• Predefined In-cell Editors for List, Date-Time and Boolean Values
• Custom Editors for Worksheet Cells
• Copy / Cut / Paste / Paste Special
• Insert / Delete Rows and Columns
• Redo / Undo
• Display Customizable Error Messages
• Highlight Invalid Values

You can bind a worksheet or cell range to various data source types: ADO.NET, SQL, custom objects, etc. A cell range can also be used as a data source for any data-aware control.